EMT Practice Test

1. Question Content...

---

Question1: Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table.
What type of design pattern is the data warehouse using?

Question2: Maria is developing a script that will perform some common analytics tasks.
In order to improve the efficiency of her workflow, she is using a package called the Tidyverse.
What programming language is she using?

Question3: Melissa wants to explore central tendency in her dataset.
Which statistic best matches her need?

Question4: A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?

Question5: A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

Question6: Which dimension of data quality ensures that data stored in multiple locations is the same?

Question7: A junior web developer is developing a new application where users can upload short videos. The first task is to create a homepage that shows the headline "Upload Your Short Videos" and a clickable button that says "upload now".
Which of the following HTML commands would help the developer to complete the task successfully?

Question8: What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Question9: What colors are commonly used for the change bars in a waterfall chart?

Question10: The ACME Corporation hired an analyst to detect data quality issues in their excel documents. Which of the following are the most common issues? (Select TWO)

Question11: You are measuring how much a child has grown over the past year and would like to express that using a percentage.
What calculation is most appropriate?

Question12: What output from a statistical test is used when performing hypothesis testing?

Question13: What test formatting option indicates that a field is required in an entity relationship diagram?

Question14: What effort has the goal of maintaining a single source of truth for the most important data elements handled by the organization?

Question15: Angela is aggregating data from CRM system with data from an employee system.
While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system.
What kind of issues is Angela facing?
Choose the best answer.

Question16: When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.
What term describes this action?

Question17: What role in a data governance is typically responsible for day-to-day oversight of data use?

Question18: Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail.
Who had the highest score?

Question19: What three technological innovations contribute to modern analytics?
Choose three answers.

Question20: Zip code,____________, and___________ uniquely identify 87% of people in the United States.

Question21: Data stewards protect the organization from legal violations that may result in costly fines and negative publicity.

Question22: Which one of the following is NOT one of the five dimensions of data quality?

Question23: How should data classifications be assigned?

Question24: What R package makes it easy to work with dates?

Question25: What is the most time-consuming of the practices that authorize international data transfers under GDPR?

Question26: Which one of the following tools would not be considered a fully featured analytics suite?

Question27: A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

Question28: A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income". The "Income Categories" would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?

Question29: Analytics reports should follow corporate style guidelines.

Question30: Which of the following contains alphanumeric values?

Question31: What analytics suite is offered by Microsoft and directly integrates with SQL Server Databases?

Question32: Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.
Which of the following systems is the most appropriate?
Choose the best answer.

Question33: Olivia has 15 people on her data analytics team. Her team's charter requires that all team members have read access to the finance, human resources, sales, and customer service areas of the corporate data warehouse.
What is the best way to provision access to her team?
Choose the best answer.

Question34: Five dogs have the following heights in millimeters:
300, 430, 170, 470, 600
Which of the following is the mean height for the five dogs?

Question35: What type of access permission system is most appropriate for a dashboard?

Question36: According to the empirical rule, what percent of thee values in a sample fall within three standard deviations of the mean in a normal distribution?

Question37: What is the final stage of the data lifecycle?

Question38: A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO).
Which of the following should be included in the report?

Question39: You are working with a dataset and want to change the names of categories that you used for different types of books.
What term best describes this action?

Question40: Data validation should occur only when data is initially brought into a organization.

Question41: A web developer wants to ensure that malicious users can't type SQL statements when they asked for input, like their username/userid.
Which of the following query optimization techniques would effectively prevent SQL Injection attacks?

Question42: What type of data is best suited for display using a tree map?

Question43: Ellen is a 17-year old student enrolled in her first year of college. Under Family Educational Rights and Privacy Act FERPA, who has the right to control disclosure of her educational records to third parties?

Question44: You are creating a dashboard that shows the total revenue for your organization broken out by a variety of factors. Which one of these is a measure, rather than a dimension?

Question45: Which one of the following programming languages is specifically designed for use in analytics applications?

Question46: What term is used to describe an interactive visualization that encourages people to explore data dynamically?

Question47: You are a database administrator and you create a precompiled query that is stored on the database server.
What have you created?

Question48: What term indicates whether an attribute's value is within an expected range?

Question49: Most data that exists in the world is structured data.